﻿
IF object_id(N'dbo.[UDS_Linkman_CustomLinkman]', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Linkman_CustomLinkman] (
        [ID]              int           NOT NULL identity(1, 1),
        [Name]            nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [Gender]          bit           NOT NULL,
        [UnitTelephone]   nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Email]           nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [UnitAddress]     nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [UnitZip]         nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [FamilyAddress]   nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
        [FamilyZip]       nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Mobile]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [FamilyTelephone] nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Memo]            nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [Age]             nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,

        CONSTRAINT [PK_UDS_Linkman_CustomLinkman] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
